%@ Language=VBScript %>
<%If session("agentusername")="" Then
ef=True
ec="授权非法,有可能是超时造成的。"
end if
if not ef then
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open Application("FreeHostDBlink")
Set dsreg = Server.CreateObject("ADODB.Recordset")
Sql="Select * from FreeHost.FreeHost_AGENT where username='"&session("agentusername")&"'"
if Instr(1,sql, ";", 1)>0 or Instr(1,sql, "--", 1)>0 then
Response.Write "非法字符!"
Response.End
end if
dsreg.Open Sql,conn,1,1
If dsreg.Eof Then
ef=True
ec="代理会员名不存在或密码出错了!"
end if
end if
if not ef then
session("agentusermoney")=dsreg("usermoney")
Set dsmoney = Server.CreateObject("ADODB.Recordset")
' Sql="Select * from FreeHost.FreeHost_moneylog where norusername='"&session("agentusername")&"' or agnusername='"&session("agentusername")&"' or agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"' order by id desc"
Sql="Select * from FreeHost.FreeHost_moneylog where (opusername='"&session("agentusername")&"' or agnusername='"&session("agentusername")&"' or agent1='"&session("agentusername")&"' or agent2='"&session("agentusername")&"') and isnew='y' and isdel is null order by id desc"
'if Request.QueryString ("op") ="all" then Sql="Select * from FreeHost.FreeHost_Product_Host order by id desc"
'if Request.QueryString ("op") ="pause" then Sql="Select * from FreeHost.FreeHost_Product_Host where endtime<'"&now&"' order by endtime desc"
'if Request.QueryString ("op") ="del" then Sql="Select * from FreeHost.FreeHost_Product_Host where endtime<'"&dateadd("d",-30,now)&"' order by endtime desc"
If IsDate(Request("starttime")) And IsDate(Request("endtime")) Then sql=Replace(sql," order by id desc"," and attime>'"&Request("starttime")&"' and attime<'"&Request("endtime")&"' order by id desc")
If Request("isadd")="y" Then sql=Replace(sql," order by id desc"," and isadd='y' order by id desc")
If Request("isadd")="n" Then sql=Replace(sql," order by id desc"," and isadd='n' order by id desc")
dsmoney.PageSize = 25
If Request("PageSize")<>"" and isnumeric(Request("PageSize")) then dsmoney.PageSize =Request("PageSize")
dsmoney.Open Sql,conn,1,1
%>
<%session("FreeHostCom").FreeHost_WR("html5")%>
财务管理
<%session("FreeHostCom").FreeHost_WR("html6")%>
您当前的可用金额:<%if session("agentusermoney")<1 and session("agentusermoney")>0 then%>0<%end if%><%=session("agentusermoney")%> 元
时间 | 增加 | 减少 | 余额 | 用户/代理 | 类别/操作人 | 原因 |
<%=dsmoney("attime")%> | <%if dsmoney("isadd")="y" then addcount=addcount+(dsmoney("usermoney")) %> "><%=replace(formatCurrency(dsmoney("usermoney"),2,-1),".00","")%> 元 <%end if%> | <%if not dsmoney("isadd")="y" then decount=decount+(dsmoney("usermoney")) %> "><%=replace(formatCurrency(dsmoney("usermoney"),2,-1),".00","")%> 元 <%end if%> | <%=dsmoney("agnEndmoney")%> 元 | "><%=dsmoney("norusername")%> <%if dsmoney("isagn")="y" then%> ">(<%=dsmoney("agnusername")%>) <%end if%><%if session("agenttype")="子代理" and dsmoney("agent1")<>session("agentusername") then%>/UP<%else%> <%if dsmoney("agent1")<>"" and dsmoney("agent1")<>session("agentusername") then%>">(<%=dsmoney("agent1")%>)<%end if%><%end if%> | "> <%if session("agenttype")="子代理" and dsmoney("agent1")<>session("agentusername") then%>UP<%else%><%=dsmoney("atspace")%><%end if%><%if dsmoney("ishand")="y" then%>手工<%end if%> | "><%=dsmoney("forwhat")%> |
本页总计 | <%=replace(formatCurrency(abs(addcount),2,-1),".00","")%> 元 | <%=replace(formatCurrency(abs(decount),2,-1),".00","")%> 元 | "> "> |